Populate drop down field from another form's subform
Question
You can find this question from this link 👉 Lock editing subform rows
Answer
You can find the solution to the question from the video below
First we need a Workflow to disable all Fields
The Parameters for the Workflow are given below

The Code Snippet is as follows
for each item in input.Order_Items
{
product_id = Products[ID == item.Products];
product_id.Sold_Stock=product_id.Sold_Stock + item.Quantity;
}
Next we need a Workflow to enable the current field row only

The Code Snippet is as follows
for each item in input.Order_Items
{
product_id = Products[ID == item.Products];
product_id.Sold_Stock=product_id.Sold_Stock + item.Quantity;
}




